-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1:3306
-- Généré le : ven. 05 mai 2023 à 06:40
-- Version du serveur : 5.7.36
-- Version de PHP : 7.4.26

START TRANSACTION;



--
-- Base de données : `pools`
--

-- --------------------------------------------------------

--
-- Structure de la table `activity`
--

CREATE TABLE IF NOT EXISTS `activity` (
  `id_activity` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `booking` tinyint(1) NOT NULL,
  `active` tinyint(1) NOT NULL,
  PRIMARY KEY (`id_activity`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `activity`
--

INSERT INTO `activity` (`id_activity`, `name`, `description`, `booking`, `active`) VALUES
(1, 'Nage libre', 'Accès aux bassins en toute autonomie, sans contrainte de temps', 0, 1),
(2, 'Cours de natation débutant', 'Apprentissage de la natation sous la supervision d\'un professeur', 1, 1),
(3, 'Cours de natation avancé', 'Approfondissement des techniques de natation sous la supervision d\'un professeur', 1, 1),
(4, 'Aquagym', 'Découverte de l\'aquagym avec un professeur', 1, 1),
(5, 'Bébés nageurs', 'Découverte du milieu aquatique pour un tout-petit (moins de 2 ans) accompagné d\'un adulte', 1, 1),
(6, 'Cours particulier', 'Apprentissage de la natation pour une personne avec un professeur', 1, 1);

-- --------------------------------------------------------

--
-- Structure de la table `code`
--

CREATE TABLE IF NOT EXISTS `code` (
  `id_code` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `id_offer` int(11) UNSIGNED NOT NULL,
  `generation_date` datetime NOT NULL,
  `code_string` char(10) COLLATE utf8_unicode_ci NOT NULL,
  `remaining_entries` int(11) NOT NULL,
  PRIMARY KEY (`id_code`),
  KEY `fk_code_offer` (`id_offer`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `code`
--

INSERT INTO `code` (`id_code`, `id_offer`, `generation_date`, `code_string`, `remaining_entries`) VALUES
(1, 1, '2022-12-27 15:06:23', 'S4UG-G8J2', 10),
(12, 8, '2022-12-27 15:09:10', '7RUT-6CNR', 10),
(13, 6, '2022-12-27 15:21:16', 'QZ4U-U2DJ', 10),
(14, 6, '2022-12-27 15:22:38', 'KLV4-W6N3', 10),
(15, 6, '2022-12-27 15:22:55', 'AKJH-E6MR', 10),
(21, 26, '2023-02-09 10:28:22', 'GD2Y-GNVT', 5),
(41, 1, '2023-03-16 06:59:11', '9EKH-S5CW', 10),
(42, 7, '2023-04-25 13:19:33', 'RDKF-3JBH', 10),
(43, 4, '2023-04-28 14:14:11', 'PH2A-91QZ', 10),
(44, 13, '2023-04-29 13:48:14', 'UXTF-XBHX', 10),
(45, 8, '2023-04-29 13:48:14', 'HBED-GZFH', 10),
(46, 21, '2023-05-03 12:09:24', 'WXWG-5H6N', 1);

-- --------------------------------------------------------

--
-- Structure de la table `lesson`
--

CREATE TABLE IF NOT EXISTS `lesson` (
  `id_lesson` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `id_pool` int(11) UNSIGNED NOT NULL,
  `id_activity` int(11) UNSIGNED NOT NULL,
  `date_time` datetime NOT NULL,
  `coach` text COLLATE utf8_unicode_ci NOT NULL,
  `capacity` int(11) NOT NULL,
  `active` tinyint(1) NOT NULL,
  PRIMARY KEY (`id_lesson`),
  KEY `fk_lesson_pool` (`id_pool`),
  KEY `fk_lesson_activity` (`id_activity`)
) ENGINE=InnoDB AUTO_INCREMENT=911 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `lesson`
--

INSERT INTO `lesson` (`id_lesson`, `id_pool`, `id_activity`, `date_time`, `coach`, `capacity`, `active`) VALUES
(1, 1, 2, '2023-03-13 08:30:00', 'Bernard PAPILLON', 10, 1),
(2, 1, 2, '2023-03-15 16:00:00', 'Bernard PAPILLON', 10, 1),
(3, 1, 2, '2023-03-18 09:30:00', 'Bernard PAPILLON', 10, 1),
(4, 1, 3, '2023-03-14 14:30:00', 'Sophie BRASSE', 10, 1),
(5, 1, 4, '2023-03-15 10:00:00', 'Sophie BRASSE', 15, 1),
(6, 1, 5, '2023-03-18 10:00:00', 'Héléna TASSION', 3, 1),
(7, 1, 6, '2023-03-13 14:00:00', 'Héléna TASSION', 1, 1),
(8, 1, 6, '2023-03-13 15:00:00', 'Héléna TASSION', 1, 1),
(9, 1, 6, '2023-03-13 16:00:00', 'Héléna TASSION', 1, 1),
(10, 1, 6, '2023-03-13 17:00:00', 'Héléna TASSION', 1, 1),
(11, 1, 6, '2023-03-16 08:30:00', 'Héléna TASSION', 1, 1),
(12, 1, 6, '2023-03-16 09:30:00', 'Héléna TASSION', 1, 1),
(13, 1, 6, '2023-03-16 10:30:00', 'Héléna TASSION', 1, 1),
(14, 1, 6, '2023-03-16 11:30:00', 'Héléna TASSION', 1, 1),
(15, 1, 6, '2023-03-15 14:00:00', 'Stacy REINE', 1, 1),
(16, 1, 6, '2023-03-15 15:00:00', 'Stacy REINE', 1, 1),
(17, 1, 6, '2023-03-15 16:00:00', 'Stacy REINE', 1, 1),
(18, 1, 6, '2023-03-15 17:00:00', 'Stacy REINE', 1, 1),
(19, 1, 6, '2023-03-17 09:00:00', 'Stacy REINE', 1, 1),
(20, 1, 6, '2023-03-17 10:00:00', 'Stacy REINE', 1, 1),
(21, 1, 6, '2023-03-17 11:00:00', 'Stacy REINE', 1, 1),
(22, 1, 6, '2023-03-17 13:00:00', 'Stacy REINE', 1, 1),
(23, 1, 6, '2023-03-17 14:00:00', 'Stacy REINE', 1, 1),
(24, 1, 6, '2023-03-17 15:00:00', 'Stacy REINE', 1, 1),
(25, 2, 2, '2023-03-13 09:00:00', 'René NUFFARD', 12, 1),
(26, 2, 2, '2023-03-14 09:00:00', 'René NUFFARD', 12, 1),
(27, 2, 2, '2023-03-15 09:00:00', 'René NUFFARD', 12, 1),
(28, 2, 2, '2023-03-16 09:00:00', 'René NUFFARD', 12, 1),
(29, 2, 2, '2023-03-17 09:00:00', 'René NUFFARD', 12, 1),
(30, 2, 2, '2023-03-18 08:30:00', 'René NUFFARD', 12, 1),
(31, 2, 2, '2023-03-13 15:00:00', 'Armand CHOW', 12, 1),
(32, 2, 2, '2023-03-14 15:00:00', 'Armand CHOW', 12, 1),
(33, 2, 2, '2023-03-15 15:00:00', 'Armand CHOW', 12, 1),
(34, 2, 2, '2023-03-16 15:00:00', 'Armand CHOW', 12, 1),
(35, 2, 2, '2023-03-17 15:00:00', 'Armand CHOW', 12, 1),
(36, 2, 2, '2023-03-18 09:30:00', 'Armand CHOW', 12, 1),
(37, 2, 3, '2023-03-15 09:00:00', 'Armand CHOW', 10, 1),
(38, 2, 3, '2023-03-17 10:30:00', 'Armand CHOW', 10, 1),
(39, 2, 3, '2023-03-18 11:00:00', 'Armand CHOW', 10, 1),
(40, 2, 4, '2023-03-16 10:00:00', 'Sophie BRASSE', 5, 1),
(41, 3, 2, '2023-03-14 07:30:00', 'Arthur PLOUF', 8, 1),
(42, 3, 2, '2023-03-14 08:30:00', 'Arthur PLOUF', 8, 1),
(43, 3, 2, '2023-03-14 09:30:00', 'Arthur PLOUF', 8, 1),
(44, 3, 2, '2023-03-14 10:30:00', 'Arthur PLOUF', 8, 1),
(45, 3, 2, '2023-03-15 07:30:00', 'Arthur PLOUF', 8, 1),
(46, 3, 2, '2023-03-15 08:30:00', 'Arthur PLOUF', 8, 1),
(47, 3, 2, '2023-03-15 09:30:00', 'Arthur PLOUF', 8, 1),
(48, 3, 2, '2023-03-15 10:30:00', 'Arthur PLOUF', 8, 1),
(49, 3, 2, '2023-03-16 07:30:00', 'Arthur PLOUF', 8, 1),
(50, 3, 2, '2023-03-16 08:30:00', 'Arthur PLOUF', 8, 1),
(51, 3, 2, '2023-03-16 09:30:00', 'Arthur PLOUF', 8, 1),
(52, 3, 2, '2023-03-16 10:30:00', 'Arthur PLOUF', 8, 1),
(53, 3, 3, '2023-03-17 09:30:00', 'Arthur PLOUF', 8, 1),
(54, 3, 3, '2023-03-17 10:30:00', 'Arthur PLOUF', 8, 1),
(55, 3, 3, '2023-03-18 09:30:00', 'Arthur PLOUF', 8, 1),
(56, 3, 3, '2023-03-18 10:30:00', 'Arthur PLOUF', 8, 1),
(57, 3, 4, '2023-03-13 16:30:00', 'Sophie BRASSE', 10, 1),
(58, 3, 4, '2023-03-17 15:30:00', 'Sophie BRASSE', 10, 1),
(59, 3, 4, '2023-03-17 16:30:00', 'Sophie BRASSE', 10, 1),
(60, 3, 5, '2023-03-17 09:30:00', 'Iris DOE', 4, 1),
(61, 3, 5, '2023-03-18 09:30:00', 'Iris DOE', 4, 1),
(62, 4, 2, '2023-03-14 10:30:00', 'Iris DOE', 10, 1),
(63, 4, 2, '2023-03-14 15:30:00', 'Iris DOE', 10, 1),
(64, 4, 2, '2023-03-15 10:30:00', 'Iris DOE', 10, 1),
(65, 4, 2, '2023-03-15 15:30:00', 'Iris DOE', 10, 1),
(66, 4, 2, '2023-03-16 10:30:00', 'Iris DOE', 10, 1),
(67, 4, 2, '2023-03-16 15:30:00', 'Iris DOE', 10, 1),
(68, 4, 3, '2023-03-13 13:30:00', 'Stacy REINE', 10, 1),
(69, 4, 3, '2023-03-13 17:30:00', 'Stacy REINE', 10, 1),
(70, 4, 3, '2023-03-14 13:30:00', 'Stacy REINE', 10, 1),
(71, 4, 3, '2023-03-14 17:30:00', 'Stacy REINE', 10, 1),
(72, 4, 3, '2023-03-16 13:30:00', 'Stacy REINE', 10, 1),
(73, 4, 3, '2023-03-16 17:30:00', 'Stacy REINE', 10, 1),
(74, 4, 6, '2023-03-13 09:30:00', 'Iris DOE', 1, 1),
(75, 4, 6, '2023-03-13 10:30:00', 'Iris DOE', 1, 1),
(76, 4, 6, '2023-03-13 11:30:00', 'Iris DOE', 1, 1),
(77, 4, 6, '2023-03-14 09:30:00', 'Iris DOE', 1, 1),
(78, 4, 6, '2023-03-14 10:30:00', 'Iris DOE', 1, 1),
(79, 4, 6, '2023-03-14 11:30:00', 'Iris DOE', 1, 1),
(80, 4, 6, '2023-03-16 09:30:00', 'Iris DOE', 1, 1),
(81, 4, 6, '2023-03-16 10:30:00', 'Iris DOE', 1, 1),
(82, 4, 6, '2023-03-16 11:30:00', 'Iris DOE', 1, 1),
(83, 4, 6, '2023-03-15 09:30:00', 'Héléna TASSION', 1, 1),
(84, 4, 6, '2023-03-15 10:30:00', 'Héléna TASSION', 1, 1),
(85, 4, 6, '2023-03-15 11:30:00', 'Héléna TASSION', 1, 1),
(86, 4, 6, '2023-03-15 09:30:00', 'Héléna TASSION', 1, 1),
(87, 4, 6, '2023-03-17 10:30:00', 'Héléna TASSION', 1, 1),
(88, 4, 6, '2023-03-17 11:30:00', 'Héléna TASSION', 1, 1),
(89, 4, 6, '2023-03-17 09:30:00', 'Héléna TASSION', 1, 1),
(90, 4, 6, '2023-03-17 10:30:00', 'Héléna TASSION', 1, 1),
(91, 4, 6, '2023-03-17 11:30:00', 'Héléna TASSION', 1, 1),
(92, 1, 2, '2023-04-10 08:30:00', 'Bernard PAPILLON', 10, 1),
(93, 1, 2, '2023-04-12 16:00:00', 'Bernard PAPILLON', 10, 1),
(94, 1, 2, '2023-04-15 09:30:00', 'Bernard PAPILLON', 10, 1),
(95, 1, 3, '2023-04-11 14:30:00', 'Sophie BRASSE', 10, 1),
(96, 1, 4, '2023-04-12 10:00:00', 'Sophie BRASSE', 15, 1),
(97, 1, 5, '2023-04-15 10:00:00', 'Héléna TASSION', 3, 1),
(98, 1, 6, '2023-04-10 14:00:00', 'Héléna TASSION', 1, 1),
(99, 1, 6, '2023-04-10 15:00:00', 'Héléna TASSION', 1, 1),
(100, 1, 6, '2023-04-10 16:00:00', 'Héléna TASSION', 1, 1),
(101, 1, 6, '2023-04-10 17:00:00', 'Héléna TASSION', 1, 1),
(102, 1, 6, '2023-04-13 08:30:00', 'Héléna TASSION', 1, 1),
(103, 1, 6, '2023-04-13 09:30:00', 'Héléna TASSION', 1, 1),
(104, 1, 6, '2023-04-13 10:30:00', 'Héléna TASSION', 1, 1),
(105, 1, 6, '2023-04-13 11:30:00', 'Héléna TASSION', 1, 1),
(106, 1, 6, '2023-04-12 14:00:00', 'Stacy REINE', 1, 1),
(107, 1, 6, '2023-04-12 15:00:00', 'Stacy REINE', 1, 1),
(108, 1, 6, '2023-04-12 16:00:00', 'Stacy REINE', 1, 1),
(109, 1, 6, '2023-04-12 17:00:00', 'Stacy REINE', 1, 1),
(110, 1, 6, '2023-04-14 09:00:00', 'Stacy REINE', 1, 1),
(111, 1, 6, '2023-04-14 10:00:00', 'Stacy REINE', 1, 1),
(112, 1, 6, '2023-04-14 11:00:00', 'Stacy REINE', 1, 1),
(113, 1, 6, '2023-04-14 13:00:00', 'Stacy REINE', 1, 1),
(114, 1, 6, '2023-04-14 14:00:00', 'Stacy REINE', 1, 1),
(115, 1, 6, '2023-04-14 15:00:00', 'Stacy REINE', 1, 1),
(116, 2, 2, '2023-04-10 09:00:00', 'René NUFFARD', 12, 1),
(117, 2, 2, '2023-04-11 09:00:00', 'René NUFFARD', 12, 1),
(118, 2, 2, '2023-04-12 09:00:00', 'René NUFFARD', 12, 1),
(119, 2, 2, '2023-04-13 09:00:00', 'René NUFFARD', 12, 1),
(120, 2, 2, '2023-04-14 09:00:00', 'René NUFFARD', 12, 1),
(121, 2, 2, '2023-04-15 08:30:00', 'René NUFFARD', 12, 1),
(122, 2, 2, '2023-04-10 15:00:00', 'Armand CHOW', 12, 1),
(123, 2, 2, '2023-04-11 15:00:00', 'Armand CHOW', 12, 1),
(124, 2, 2, '2023-04-12 15:00:00', 'Armand CHOW', 12, 1),
(125, 2, 2, '2023-04-13 15:00:00', 'Armand CHOW', 12, 1),
(126, 2, 2, '2023-04-14 15:00:00', 'Armand CHOW', 12, 1),
(127, 2, 2, '2023-04-15 09:30:00', 'Armand CHOW', 12, 1),
(128, 2, 3, '2023-04-12 09:00:00', 'Armand CHOW', 10, 1),
(129, 2, 3, '2023-04-14 10:30:00', 'Armand CHOW', 10, 1),
(130, 2, 3, '2023-04-15 11:00:00', 'Armand CHOW', 10, 1),
(131, 2, 4, '2023-04-13 10:00:00', 'Sophie BRASSE', 5, 1),
(132, 3, 2, '2023-04-11 07:30:00', 'Arthur PLOUF', 8, 1),
(133, 3, 2, '2023-04-11 08:30:00', 'Arthur PLOUF', 8, 1),
(134, 3, 2, '2023-04-11 09:30:00', 'Arthur PLOUF', 8, 1),
(135, 3, 2, '2023-04-11 10:30:00', 'Arthur PLOUF', 8, 1),
(136, 3, 2, '2023-04-12 07:30:00', 'Arthur PLOUF', 8, 1),
(137, 3, 2, '2023-04-12 08:30:00', 'Arthur PLOUF', 8, 1),
(138, 3, 2, '2023-04-12 09:30:00', 'Arthur PLOUF', 8, 1),
(139, 3, 2, '2023-04-12 10:30:00', 'Arthur PLOUF', 8, 1),
(140, 3, 2, '2023-04-13 07:30:00', 'Arthur PLOUF', 8, 1),
(141, 3, 2, '2023-04-13 08:30:00', 'Arthur PLOUF', 8, 1),
(142, 3, 2, '2023-04-13 09:30:00', 'Arthur PLOUF', 8, 1),
(143, 3, 2, '2023-04-13 10:30:00', 'Arthur PLOUF', 8, 1),
(144, 3, 3, '2023-04-14 09:30:00', 'Arthur PLOUF', 8, 1),
(145, 3, 3, '2023-04-14 10:30:00', 'Arthur PLOUF', 8, 1),
(146, 3, 3, '2023-04-15 09:30:00', 'Arthur PLOUF', 8, 1),
(147, 3, 3, '2023-04-15 10:30:00', 'Arthur PLOUF', 8, 1),
(148, 3, 4, '2023-04-10 16:30:00', 'Sophie BRASSE', 10, 1),
(149, 3, 4, '2023-04-14 15:30:00', 'Sophie BRASSE', 10, 1),
(150, 3, 4, '2023-04-14 16:30:00', 'Sophie BRASSE', 10, 1),
(151, 3, 5, '2023-04-14 09:30:00', 'Iris DOE', 4, 1),
(152, 3, 5, '2023-04-15 09:30:00', 'Iris DOE', 4, 1),
(153, 4, 2, '2023-04-11 10:30:00', 'Iris DOE', 10, 1),
(154, 4, 2, '2023-04-11 15:30:00', 'Iris DOE', 10, 1),
(155, 4, 2, '2023-04-12 10:30:00', 'Iris DOE', 10, 1),
(156, 4, 2, '2023-04-12 15:30:00', 'Iris DOE', 10, 1),
(157, 4, 2, '2023-04-13 10:30:00', 'Iris DOE', 10, 1),
(158, 4, 2, '2023-04-13 15:30:00', 'Iris DOE', 10, 1),
(159, 4, 3, '2023-04-10 13:30:00', 'Stacy REINE', 10, 1),
(160, 4, 3, '2023-04-10 17:30:00', 'Stacy REINE', 10, 1),
(161, 4, 3, '2023-04-11 13:30:00', 'Stacy REINE', 10, 1),
(162, 4, 3, '2023-04-11 17:30:00', 'Stacy REINE', 10, 1),
(163, 4, 3, '2023-04-13 13:30:00', 'Stacy REINE', 10, 1),
(164, 4, 3, '2023-04-13 17:30:00', 'Stacy REINE', 10, 1),
(165, 4, 6, '2023-04-10 09:30:00', 'Iris DOE', 1, 1),
(166, 4, 6, '2023-04-10 10:30:00', 'Iris DOE', 1, 1),
(167, 4, 6, '2023-04-10 11:30:00', 'Iris DOE', 1, 1),
(168, 4, 6, '2023-04-11 09:30:00', 'Iris DOE', 1, 1),
(169, 4, 6, '2023-04-11 10:30:00', 'Iris DOE', 1, 1),
(170, 4, 6, '2023-04-11 11:30:00', 'Iris DOE', 1, 1),
(171, 4, 6, '2023-04-13 09:30:00', 'Iris DOE', 1, 1),
(172, 4, 6, '2023-04-13 10:30:00', 'Iris DOE', 1, 1),
(173, 4, 6, '2023-04-13 11:30:00', 'Iris DOE', 1, 1),
(174, 4, 6, '2023-04-12 09:30:00', 'Héléna TASSION', 1, 1),
(175, 4, 6, '2023-04-12 10:30:00', 'Héléna TASSION', 1, 1),
(176, 4, 6, '2023-04-12 11:30:00', 'Héléna TASSION', 1, 1),
(177, 4, 6, '2023-04-12 09:30:00', 'Héléna TASSION', 1, 1),
(178, 4, 6, '2023-04-14 10:30:00', 'Héléna TASSION', 1, 1),
(179, 4, 6, '2023-04-14 11:30:00', 'Héléna TASSION', 1, 1),
(180, 4, 6, '2023-04-14 09:30:00', 'Héléna TASSION', 1, 1),
(181, 4, 6, '2023-04-14 10:30:00', 'Héléna TASSION', 1, 1),
(182, 4, 6, '2023-04-14 11:30:00', 'Héléna TASSION', 1, 1),
(183, 1, 2, '2023-05-08 08:30:00', 'Bernard PAPILLON', 10, 1),
(184, 1, 2, '2023-05-10 16:00:00', 'Bernard PAPILLON', 10, 1),
(185, 1, 2, '2023-05-13 09:30:00', 'Bernard PAPILLON', 10, 1),
(186, 1, 3, '2023-05-09 14:30:00', 'Sophie BRASSE', 10, 1),
(187, 1, 4, '2023-05-10 10:00:00', 'Sophie BRASSE', 15, 1),
(188, 1, 5, '2023-05-13 10:00:00', 'Héléna TASSION', 3, 1),
(189, 1, 6, '2023-05-08 14:00:00', 'Héléna TASSION', 1, 1),
(190, 1, 6, '2023-05-08 15:00:00', 'Héléna TASSION', 1, 1),
(191, 1, 6, '2023-05-08 16:00:00', 'Héléna TASSION', 1, 1),
(192, 1, 6, '2023-05-08 17:00:00', 'Héléna TASSION', 1, 1),
(193, 1, 6, '2023-05-11 08:30:00', 'Héléna TASSION', 1, 1),
(194, 1, 6, '2023-05-11 09:30:00', 'Héléna TASSION', 1, 1),
(195, 1, 6, '2023-05-11 10:30:00', 'Héléna TASSION', 1, 1),
(196, 1, 6, '2023-05-11 11:30:00', 'Héléna TASSION', 1, 1),
(197, 1, 6, '2023-05-10 14:00:00', 'Stacy REINE', 1, 1),
(198, 1, 6, '2023-05-10 15:00:00', 'Stacy REINE', 1, 1),
(199, 1, 6, '2023-05-10 16:00:00', 'Stacy REINE', 1, 1),
(200, 1, 6, '2023-05-10 17:00:00', 'Stacy REINE', 1, 1),
(201, 1, 6, '2023-05-12 09:00:00', 'Stacy REINE', 1, 1),
(202, 1, 6, '2023-05-12 10:00:00', 'Stacy REINE', 1, 1),
(203, 1, 6, '2023-05-12 11:00:00', 'Stacy REINE', 1, 1),
(204, 1, 6, '2023-05-12 13:00:00', 'Stacy REINE', 1, 1),
(205, 1, 6, '2023-05-12 14:00:00', 'Stacy REINE', 1, 1),
(206, 1, 6, '2023-05-12 15:00:00', 'Stacy REINE', 1, 1),
(207, 2, 2, '2023-05-08 09:00:00', 'René NUFFARD', 12, 1),
(208, 2, 2, '2023-05-09 09:00:00', 'René NUFFARD', 12, 1),
(209, 2, 2, '2023-05-10 09:00:00', 'René NUFFARD', 12, 1),
(210, 2, 2, '2023-05-11 09:00:00', 'René NUFFARD', 12, 1),
(211, 2, 2, '2023-05-12 09:00:00', 'René NUFFARD', 12, 1),
(212, 2, 2, '2023-05-13 08:30:00', 'René NUFFARD', 12, 1),
(213, 2, 2, '2023-05-08 15:00:00', 'Armand CHOW', 12, 1),
(214, 2, 2, '2023-05-09 15:00:00', 'Armand CHOW', 12, 1),
(215, 2, 2, '2023-05-10 15:00:00', 'Armand CHOW', 12, 1),
(216, 2, 2, '2023-05-11 15:00:00', 'Armand CHOW', 12, 1),
(217, 2, 2, '2023-05-12 15:00:00', 'Armand CHOW', 12, 1),
(218, 2, 2, '2023-05-13 09:30:00', 'Armand CHOW', 12, 1),
(219, 2, 3, '2023-05-10 09:00:00', 'Armand CHOW', 10, 1),
(220, 2, 3, '2023-05-12 10:30:00', 'Armand CHOW', 10, 1),
(221, 2, 3, '2023-05-13 11:00:00', 'Armand CHOW', 10, 1),
(222, 2, 4, '2023-05-11 10:00:00', 'Sophie BRASSE', 5, 1),
(223, 3, 2, '2023-05-09 07:30:00', 'Arthur PLOUF', 8, 1),
(224, 3, 2, '2023-05-09 08:30:00', 'Arthur PLOUF', 8, 1),
(225, 3, 2, '2023-05-09 09:30:00', 'Arthur PLOUF', 8, 1),
(226, 3, 2, '2023-05-09 10:30:00', 'Arthur PLOUF', 8, 1),
(227, 3, 2, '2023-05-10 07:30:00', 'Arthur PLOUF', 8, 1),
(228, 3, 2, '2023-05-10 08:30:00', 'Arthur PLOUF', 8, 1),
(229, 3, 2, '2023-05-10 09:30:00', 'Arthur PLOUF', 8, 1),
(230, 3, 2, '2023-05-10 10:30:00', 'Arthur PLOUF', 8, 1),
(231, 3, 2, '2023-05-11 07:30:00', 'Arthur PLOUF', 8, 1),
(232, 3, 2, '2023-05-11 08:30:00', 'Arthur PLOUF', 8, 1),
(233, 3, 2, '2023-05-11 09:30:00', 'Arthur PLOUF', 8, 1),
(234, 3, 2, '2023-05-11 10:30:00', 'Arthur PLOUF', 8, 1),
(235, 3, 3, '2023-05-12 09:30:00', 'Arthur PLOUF', 8, 1),
(236, 3, 3, '2023-05-12 10:30:00', 'Arthur PLOUF', 8, 1),
(237, 3, 3, '2023-05-13 09:30:00', 'Arthur PLOUF', 8, 1),
(238, 3, 3, '2023-05-13 10:30:00', 'Arthur PLOUF', 8, 1),
(239, 3, 4, '2023-05-08 16:30:00', 'Sophie BRASSE', 10, 1),
(240, 3, 4, '2023-05-12 15:30:00', 'Sophie BRASSE', 10, 1),
(241, 3, 4, '2023-05-12 16:30:00', 'Sophie BRASSE', 10, 1),
(242, 3, 5, '2023-05-12 09:30:00', 'Iris DOE', 4, 1),
(243, 3, 5, '2023-05-13 09:30:00', 'Iris DOE', 4, 1),
(244, 4, 2, '2023-05-09 10:30:00', 'Iris DOE', 10, 1),
(245, 4, 2, '2023-05-09 15:30:00', 'Iris DOE', 10, 1),
(246, 4, 2, '2023-05-10 10:30:00', 'Iris DOE', 10, 1),
(247, 4, 2, '2023-05-10 15:30:00', 'Iris DOE', 10, 1),
(248, 4, 2, '2023-05-11 10:30:00', 'Iris DOE', 10, 1),
(249, 4, 2, '2023-05-11 15:30:00', 'Iris DOE', 10, 1),
(250, 4, 3, '2023-05-08 13:30:00', 'Stacy REINE', 10, 1),
(251, 4, 3, '2023-05-08 17:30:00', 'Stacy REINE', 10, 1),
(252, 4, 3, '2023-05-09 13:30:00', 'Stacy REINE', 10, 1),
(253, 4, 3, '2023-05-09 17:30:00', 'Stacy REINE', 10, 1),
(254, 4, 3, '2023-05-11 13:30:00', 'Stacy REINE', 10, 1),
(255, 4, 3, '2023-05-11 17:30:00', 'Stacy REINE', 10, 1),
(256, 4, 6, '2023-05-08 09:30:00', 'Iris DOE', 1, 1),
(257, 4, 6, '2023-05-08 10:30:00', 'Iris DOE', 1, 1),
(258, 4, 6, '2023-05-08 11:30:00', 'Iris DOE', 1, 1),
(259, 4, 6, '2023-05-09 09:30:00', 'Iris DOE', 1, 1),
(260, 4, 6, '2023-05-09 10:30:00', 'Iris DOE', 1, 1),
(261, 4, 6, '2023-05-09 11:30:00', 'Iris DOE', 1, 1),
(262, 4, 6, '2023-05-11 09:30:00', 'Iris DOE', 1, 1),
(263, 4, 6, '2023-05-11 10:30:00', 'Iris DOE', 1, 1),
(264, 4, 6, '2023-05-11 11:30:00', 'Iris DOE', 1, 1),
(265, 4, 6, '2023-05-10 09:30:00', 'Héléna TASSION', 1, 1),
(266, 4, 6, '2023-05-10 10:30:00', 'Héléna TASSION', 1, 1),
(267, 4, 6, '2023-05-10 11:30:00', 'Héléna TASSION', 1, 1),
(268, 4, 6, '2023-05-10 09:30:00', 'Héléna TASSION', 1, 1),
(269, 4, 6, '2023-05-12 10:30:00', 'Héléna TASSION', 1, 1),
(270, 4, 6, '2023-05-12 11:30:00', 'Héléna TASSION', 1, 1),
(271, 4, 6, '2023-05-12 09:30:00', 'Héléna TASSION', 1, 1),
(272, 4, 6, '2023-05-12 10:30:00', 'Héléna TASSION', 1, 1),
(273, 4, 6, '2023-05-12 11:30:00', 'Héléna TASSION', 1, 1),
(274, 1, 2, '2023-05-15 08:30:00', 'Bernard PAPILLON', 10, 1),
(275, 1, 2, '2023-05-17 16:00:00', 'Bernard PAPILLON', 10, 1),
(276, 1, 2, '2023-05-20 09:30:00', 'Bernard PAPILLON', 10, 1),
(277, 1, 3, '2023-05-16 14:30:00', 'Sophie BRASSE', 10, 1),
(278, 1, 4, '2023-05-17 10:00:00', 'Sophie BRASSE', 15, 1),
(279, 1, 5, '2023-05-20 10:00:00', 'Héléna TASSION', 3, 1),
(280, 1, 6, '2023-05-15 14:00:00', 'Héléna TASSION', 1, 1),
(281, 1, 6, '2023-05-15 15:00:00', 'Héléna TASSION', 1, 1),
(282, 1, 6, '2023-05-15 16:00:00', 'Héléna TASSION', 1, 1),
(283, 1, 6, '2023-05-15 17:00:00', 'Héléna TASSION', 1, 1),
(284, 1, 6, '2023-05-18 08:30:00', 'Héléna TASSION', 1, 1),
(285, 1, 6, '2023-05-18 09:30:00', 'Héléna TASSION', 1, 1),
(286, 1, 6, '2023-05-18 10:30:00', 'Héléna TASSION', 1, 1),
(287, 1, 6, '2023-05-18 11:30:00', 'Héléna TASSION', 1, 1),
(288, 1, 6, '2023-05-17 14:00:00', 'Stacy REINE', 1, 1),
(289, 1, 6, '2023-05-17 15:00:00', 'Stacy REINE', 1, 1),
(290, 1, 6, '2023-05-17 16:00:00', 'Stacy REINE', 1, 1),
(291, 1, 6, '2023-05-17 17:00:00', 'Stacy REINE', 1, 1),
(292, 1, 6, '2023-05-19 09:00:00', 'Stacy REINE', 1, 1),
(293, 1, 6, '2023-05-19 10:00:00', 'Stacy REINE', 1, 1),
(294, 1, 6, '2023-05-19 11:00:00', 'Stacy REINE', 1, 1),
(295, 1, 6, '2023-05-19 13:00:00', 'Stacy REINE', 1, 1),
(296, 1, 6, '2023-05-19 14:00:00', 'Stacy REINE', 1, 1),
(297, 1, 6, '2023-05-19 15:00:00', 'Stacy REINE', 1, 1),
(298, 2, 2, '2023-05-15 09:00:00', 'René NUFFARD', 12, 1),
(299, 2, 2, '2023-05-16 09:00:00', 'René NUFFARD', 12, 1),
(300, 2, 2, '2023-05-17 09:00:00', 'René NUFFARD', 12, 1),
(301, 2, 2, '2023-05-18 09:00:00', 'René NUFFARD', 12, 1),
(302, 2, 2, '2023-05-19 09:00:00', 'René NUFFARD', 12, 1),
(303, 2, 2, '2023-05-20 08:30:00', 'René NUFFARD', 12, 1),
(304, 2, 2, '2023-05-15 15:00:00', 'Armand CHOW', 12, 1),
(305, 2, 2, '2023-05-16 15:00:00', 'Armand CHOW', 12, 1),
(306, 2, 2, '2023-05-17 15:00:00', 'Armand CHOW', 12, 1),
(307, 2, 2, '2023-05-18 15:00:00', 'Armand CHOW', 12, 1),
(308, 2, 2, '2023-05-19 15:00:00', 'Armand CHOW', 12, 1),
(309, 2, 2, '2023-05-20 09:30:00', 'Armand CHOW', 12, 1),
(310, 2, 3, '2023-05-17 09:00:00', 'Armand CHOW', 10, 1),
(311, 2, 3, '2023-05-19 10:30:00', 'Armand CHOW', 10, 1),
(312, 2, 3, '2023-05-20 11:00:00', 'Armand CHOW', 10, 1),
(313, 2, 4, '2023-05-18 10:00:00', 'Sophie BRASSE', 5, 1),
(314, 3, 2, '2023-05-16 07:30:00', 'Arthur PLOUF', 8, 1),
(315, 3, 2, '2023-05-16 08:30:00', 'Arthur PLOUF', 8, 1),
(316, 3, 2, '2023-05-16 09:30:00', 'Arthur PLOUF', 8, 1),
(317, 3, 2, '2023-05-16 10:30:00', 'Arthur PLOUF', 8, 1),
(318, 3, 2, '2023-05-17 07:30:00', 'Arthur PLOUF', 8, 1),
(319, 3, 2, '2023-05-17 08:30:00', 'Arthur PLOUF', 8, 1),
(320, 3, 2, '2023-05-17 09:30:00', 'Arthur PLOUF', 8, 1),
(321, 3, 2, '2023-05-17 10:30:00', 'Arthur PLOUF', 8, 1),
(322, 3, 2, '2023-05-18 07:30:00', 'Arthur PLOUF', 8, 1),
(323, 3, 2, '2023-05-18 08:30:00', 'Arthur PLOUF', 8, 1),
(324, 3, 2, '2023-05-18 09:30:00', 'Arthur PLOUF', 8, 1),
(325, 3, 2, '2023-05-18 10:30:00', 'Arthur PLOUF', 8, 1),
(326, 3, 3, '2023-05-19 09:30:00', 'Arthur PLOUF', 8, 1),
(327, 3, 3, '2023-05-19 10:30:00', 'Arthur PLOUF', 8, 1),
(328, 3, 3, '2023-05-20 09:30:00', 'Arthur PLOUF', 8, 1),
(329, 3, 3, '2023-05-20 10:30:00', 'Arthur PLOUF', 8, 1),
(330, 3, 4, '2023-05-15 16:30:00', 'Sophie BRASSE', 10, 1),
(331, 3, 4, '2023-05-19 15:30:00', 'Sophie BRASSE', 10, 1),
(332, 3, 4, '2023-05-19 16:30:00', 'Sophie BRASSE', 10, 1),
(333, 3, 5, '2023-05-19 09:30:00', 'Iris DOE', 4, 1),
(334, 3, 5, '2023-05-20 09:30:00', 'Iris DOE', 4, 1),
(335, 4, 2, '2023-05-16 10:30:00', 'Iris DOE', 10, 1),
(336, 4, 2, '2023-05-16 15:30:00', 'Iris DOE', 10, 1),
(337, 4, 2, '2023-05-17 10:30:00', 'Iris DOE', 10, 1),
(338, 4, 2, '2023-05-17 15:30:00', 'Iris DOE', 10, 1),
(339, 4, 2, '2023-05-18 10:30:00', 'Iris DOE', 10, 1),
(340, 4, 2, '2023-05-18 15:30:00', 'Iris DOE', 10, 1),
(341, 4, 3, '2023-05-15 13:30:00', 'Stacy REINE', 10, 1),
(342, 4, 3, '2023-05-15 17:30:00', 'Stacy REINE', 10, 1),
(343, 4, 3, '2023-05-16 13:30:00', 'Stacy REINE', 10, 1),
(344, 4, 3, '2023-05-16 17:30:00', 'Stacy REINE', 10, 1),
(345, 4, 3, '2023-05-18 13:30:00', 'Stacy REINE', 10, 1),
(346, 4, 3, '2023-05-18 17:30:00', 'Stacy REINE', 10, 1),
(347, 4, 6, '2023-05-15 09:30:00', 'Iris DOE', 1, 1),
(348, 4, 6, '2023-05-15 10:30:00', 'Iris DOE', 1, 1),
(349, 4, 6, '2023-05-15 11:30:00', 'Iris DOE', 1, 1),
(350, 4, 6, '2023-05-16 09:30:00', 'Iris DOE', 1, 1),
(351, 4, 6, '2023-05-16 10:30:00', 'Iris DOE', 1, 1),
(352, 4, 6, '2023-05-16 11:30:00', 'Iris DOE', 1, 1),
(353, 4, 6, '2023-05-18 09:30:00', 'Iris DOE', 1, 1),
(354, 4, 6, '2023-05-18 10:30:00', 'Iris DOE', 1, 1),
(355, 4, 6, '2023-05-18 11:30:00', 'Iris DOE', 1, 1),
(356, 4, 6, '2023-05-17 09:30:00', 'Héléna TASSION', 1, 1),
(357, 4, 6, '2023-05-17 10:30:00', 'Héléna TASSION', 1, 1),
(358, 4, 6, '2023-05-17 11:30:00', 'Héléna TASSION', 1, 1),
(359, 4, 6, '2023-05-17 09:30:00', 'Héléna TASSION', 1, 1),
(360, 4, 6, '2023-05-19 10:30:00', 'Héléna TASSION', 1, 1),
(361, 4, 6, '2023-05-19 11:30:00', 'Héléna TASSION', 1, 1),
(362, 4, 6, '2023-05-19 09:30:00', 'Héléna TASSION', 1, 1),
(363, 4, 6, '2023-05-19 10:30:00', 'Héléna TASSION', 1, 1),
(364, 4, 6, '2023-05-19 11:30:00', 'Héléna TASSION', 1, 1),
(365, 1, 2, '2023-05-22 08:30:00', 'Bernard PAPILLON', 10, 1),
(366, 1, 2, '2023-05-24 16:00:00', 'Bernard PAPILLON', 10, 1),
(367, 1, 2, '2023-05-27 09:30:00', 'Bernard PAPILLON', 10, 1),
(368, 1, 3, '2023-05-23 14:30:00', 'Sophie BRASSE', 10, 1),
(369, 1, 4, '2023-05-24 10:00:00', 'Sophie BRASSE', 15, 1),
(370, 1, 5, '2023-05-27 10:00:00', 'Héléna TASSION', 3, 1),
(371, 1, 6, '2023-05-22 14:00:00', 'Héléna TASSION', 1, 1),
(372, 1, 6, '2023-05-22 15:00:00', 'Héléna TASSION', 1, 1),
(373, 1, 6, '2023-05-22 16:00:00', 'Héléna TASSION', 1, 1),
(374, 1, 6, '2023-05-22 17:00:00', 'Héléna TASSION', 1, 1),
(375, 1, 6, '2023-05-25 08:30:00', 'Héléna TASSION', 1, 1),
(376, 1, 6, '2023-05-25 09:30:00', 'Héléna TASSION', 1, 1),
(377, 1, 6, '2023-05-25 10:30:00', 'Héléna TASSION', 1, 1),
(378, 1, 6, '2023-05-25 11:30:00', 'Héléna TASSION', 1, 1),
(379, 1, 6, '2023-05-24 14:00:00', 'Stacy REINE', 1, 1),
(380, 1, 6, '2023-05-24 15:00:00', 'Stacy REINE', 1, 1),
(381, 1, 6, '2023-05-24 16:00:00', 'Stacy REINE', 1, 1),
(382, 1, 6, '2023-05-24 17:00:00', 'Stacy REINE', 1, 1),
(383, 1, 6, '2023-05-26 09:00:00', 'Stacy REINE', 1, 1),
(384, 1, 6, '2023-05-26 10:00:00', 'Stacy REINE', 1, 1),
(385, 1, 6, '2023-05-26 11:00:00', 'Stacy REINE', 1, 1),
(386, 1, 6, '2023-05-26 13:00:00', 'Stacy REINE', 1, 1),
(387, 1, 6, '2023-05-26 14:00:00', 'Stacy REINE', 1, 1),
(388, 1, 6, '2023-05-26 15:00:00', 'Stacy REINE', 1, 1),
(389, 2, 2, '2023-05-22 09:00:00', 'René NUFFARD', 12, 1),
(390, 2, 2, '2023-05-23 09:00:00', 'René NUFFARD', 12, 1),
(391, 2, 2, '2023-05-24 09:00:00', 'René NUFFARD', 12, 1),
(392, 2, 2, '2023-05-25 09:00:00', 'René NUFFARD', 12, 1),
(393, 2, 2, '2023-05-26 09:00:00', 'René NUFFARD', 12, 1),
(394, 2, 2, '2023-05-27 08:30:00', 'René NUFFARD', 12, 1),
(395, 2, 2, '2023-05-22 15:00:00', 'Armand CHOW', 12, 1),
(396, 2, 2, '2023-05-23 15:00:00', 'Armand CHOW', 12, 1),
(397, 2, 2, '2023-05-24 15:00:00', 'Armand CHOW', 12, 1),
(398, 2, 2, '2023-05-25 15:00:00', 'Armand CHOW', 12, 1),
(399, 2, 2, '2023-05-26 15:00:00', 'Armand CHOW', 12, 1),
(400, 2, 2, '2023-05-27 09:30:00', 'Armand CHOW', 12, 1),
(401, 2, 3, '2023-05-24 09:00:00', 'Armand CHOW', 10, 1),
(402, 2, 3, '2023-05-26 10:30:00', 'Armand CHOW', 10, 1),
(403, 2, 3, '2023-05-27 11:00:00', 'Armand CHOW', 10, 1),
(404, 2, 4, '2023-05-25 10:00:00', 'Sophie BRASSE', 5, 1),
(405, 3, 2, '2023-05-23 07:30:00', 'Arthur PLOUF', 8, 1),
(406, 3, 2, '2023-05-23 08:30:00', 'Arthur PLOUF', 8, 1),
(407, 3, 2, '2023-05-23 09:30:00', 'Arthur PLOUF', 8, 1),
(408, 3, 2, '2023-05-23 10:30:00', 'Arthur PLOUF', 8, 1),
(409, 3, 2, '2023-05-24 07:30:00', 'Arthur PLOUF', 8, 1),
(410, 3, 2, '2023-05-24 08:30:00', 'Arthur PLOUF', 8, 1),
(411, 3, 2, '2023-05-24 09:30:00', 'Arthur PLOUF', 8, 1),
(412, 3, 2, '2023-05-24 10:30:00', 'Arthur PLOUF', 8, 1),
(413, 3, 2, '2023-05-25 07:30:00', 'Arthur PLOUF', 8, 1),
(414, 3, 2, '2023-05-25 08:30:00', 'Arthur PLOUF', 8, 1),
(415, 3, 2, '2023-05-25 09:30:00', 'Arthur PLOUF', 8, 1),
(416, 3, 2, '2023-05-25 10:30:00', 'Arthur PLOUF', 8, 1),
(417, 3, 3, '2023-05-26 09:30:00', 'Arthur PLOUF', 8, 1),
(418, 3, 3, '2023-05-26 10:30:00', 'Arthur PLOUF', 8, 1),
(419, 3, 3, '2023-05-27 09:30:00', 'Arthur PLOUF', 8, 1),
(420, 3, 3, '2023-05-27 10:30:00', 'Arthur PLOUF', 8, 1),
(421, 3, 4, '2023-05-22 16:30:00', 'Sophie BRASSE', 10, 1),
(422, 3, 4, '2023-05-26 15:30:00', 'Sophie BRASSE', 10, 1),
(423, 3, 4, '2023-05-26 16:30:00', 'Sophie BRASSE', 10, 1),
(424, 3, 5, '2023-05-26 09:30:00', 'Iris DOE', 4, 1),
(425, 3, 5, '2023-05-27 09:30:00', 'Iris DOE', 4, 1),
(426, 4, 2, '2023-05-23 10:30:00', 'Iris DOE', 10, 1),
(427, 4, 2, '2023-05-23 15:30:00', 'Iris DOE', 10, 1),
(428, 4, 2, '2023-05-24 10:30:00', 'Iris DOE', 10, 1),
(429, 4, 2, '2023-05-24 15:30:00', 'Iris DOE', 10, 1),
(430, 4, 2, '2023-05-25 10:30:00', 'Iris DOE', 10, 1),
(431, 4, 2, '2023-05-25 15:30:00', 'Iris DOE', 10, 1),
(432, 4, 3, '2023-05-22 13:30:00', 'Stacy REINE', 10, 1),
(433, 4, 3, '2023-05-22 17:30:00', 'Stacy REINE', 10, 1),
(434, 4, 3, '2023-05-23 13:30:00', 'Stacy REINE', 10, 1),
(435, 4, 3, '2023-05-23 17:30:00', 'Stacy REINE', 10, 1),
(436, 4, 3, '2023-05-25 13:30:00', 'Stacy REINE', 10, 1),
(437, 4, 3, '2023-05-25 17:30:00', 'Stacy REINE', 10, 1),
(438, 4, 6, '2023-05-22 09:30:00', 'Iris DOE', 1, 1),
(439, 4, 6, '2023-05-22 10:30:00', 'Iris DOE', 1, 1),
(440, 4, 6, '2023-05-22 11:30:00', 'Iris DOE', 1, 1),
(441, 4, 6, '2023-05-23 09:30:00', 'Iris DOE', 1, 1),
(442, 4, 6, '2023-05-23 10:30:00', 'Iris DOE', 1, 1),
(443, 4, 6, '2023-05-23 11:30:00', 'Iris DOE', 1, 1),
(444, 4, 6, '2023-05-25 09:30:00', 'Iris DOE', 1, 1),
(445, 4, 6, '2023-05-25 10:30:00', 'Iris DOE', 1, 1),
(446, 4, 6, '2023-05-25 11:30:00', 'Iris DOE', 1, 1),
(447, 4, 6, '2023-05-24 09:30:00', 'Héléna TASSION', 1, 1),
(448, 4, 6, '2023-05-24 10:30:00', 'Héléna TASSION', 1, 1),
(449, 4, 6, '2023-05-24 11:30:00', 'Héléna TASSION', 1, 1),
(450, 4, 6, '2023-05-24 09:30:00', 'Héléna TASSION', 1, 1),
(451, 4, 6, '2023-05-26 10:30:00', 'Héléna TASSION', 1, 1),
(452, 4, 6, '2023-05-26 11:30:00', 'Héléna TASSION', 1, 1),
(453, 4, 6, '2023-05-26 09:30:00', 'Héléna TASSION', 1, 1),
(454, 4, 6, '2023-05-26 10:30:00', 'Héléna TASSION', 1, 1),
(455, 4, 6, '2023-05-26 11:30:00', 'Héléna TASSION', 1, 1),
(456, 1, 2, '2023-05-29 08:30:00', 'Bernard PAPILLON', 10, 1),
(457, 1, 2, '2023-05-31 16:00:00', 'Bernard PAPILLON', 10, 1),
(458, 1, 2, '2023-06-03 09:30:00', 'Bernard PAPILLON', 10, 1),
(459, 1, 3, '2023-05-30 14:30:00', 'Sophie BRASSE', 10, 1),
(460, 1, 4, '2023-05-31 10:00:00', 'Sophie BRASSE', 15, 1),
(461, 1, 5, '2023-06-03 10:00:00', 'Héléna TASSION', 3, 1),
(462, 1, 6, '2023-05-29 14:00:00', 'Héléna TASSION', 1, 1),
(463, 1, 6, '2023-05-29 15:00:00', 'Héléna TASSION', 1, 1),
(464, 1, 6, '2023-05-29 16:00:00', 'Héléna TASSION', 1, 1),
(465, 1, 6, '2023-05-29 17:00:00', 'Héléna TASSION', 1, 1),
(466, 1, 6, '2023-06-01 08:30:00', 'Héléna TASSION', 1, 1),
(467, 1, 6, '2023-06-01 09:30:00', 'Héléna TASSION', 1, 1),
(468, 1, 6, '2023-06-01 10:30:00', 'Héléna TASSION', 1, 1),
(469, 1, 6, '2023-06-01 11:30:00', 'Héléna TASSION', 1, 1),
(470, 1, 6, '2023-05-31 14:00:00', 'Stacy REINE', 1, 1),
(471, 1, 6, '2023-05-31 15:00:00', 'Stacy REINE', 1, 1),
(472, 1, 6, '2023-05-31 16:00:00', 'Stacy REINE', 1, 1),
(473, 1, 6, '2023-05-31 17:00:00', 'Stacy REINE', 1, 1),
(474, 1, 6, '2023-06-02 09:00:00', 'Stacy REINE', 1, 1),
(475, 1, 6, '2023-06-02 10:00:00', 'Stacy REINE', 1, 1),
(476, 1, 6, '2023-06-02 11:00:00', 'Stacy REINE', 1, 1),
(477, 1, 6, '2023-06-02 13:00:00', 'Stacy REINE', 1, 1),
(478, 1, 6, '2023-06-02 14:00:00', 'Stacy REINE', 1, 1),
(479, 1, 6, '2023-06-02 15:00:00', 'Stacy REINE', 1, 1),
(480, 2, 2, '2023-05-29 09:00:00', 'René NUFFARD', 12, 1),
(481, 2, 2, '2023-05-30 09:00:00', 'René NUFFARD', 12, 1),
(482, 2, 2, '2023-05-31 09:00:00', 'René NUFFARD', 12, 1),
(483, 2, 2, '2023-06-01 09:00:00', 'René NUFFARD', 12, 1),
(484, 2, 2, '2023-06-02 09:00:00', 'René NUFFARD', 12, 1),
(485, 2, 2, '2023-06-03 08:30:00', 'René NUFFARD', 12, 1),
(486, 2, 2, '2023-05-29 15:00:00', 'Armand CHOW', 12, 1),
(487, 2, 2, '2023-05-30 15:00:00', 'Armand CHOW', 12, 1),
(488, 2, 2, '2023-05-31 15:00:00', 'Armand CHOW', 12, 1),
(489, 2, 2, '2023-06-01 15:00:00', 'Armand CHOW', 12, 1),
(490, 2, 2, '2023-06-02 15:00:00', 'Armand CHOW', 12, 1),
(491, 2, 2, '2023-06-03 09:30:00', 'Armand CHOW', 12, 1),
(492, 2, 3, '2023-05-31 09:00:00', 'Armand CHOW', 10, 1),
(493, 2, 3, '2023-06-02 10:30:00', 'Armand CHOW', 10, 1),
(494, 2, 3, '2023-06-03 11:00:00', 'Armand CHOW', 10, 1),
(495, 2, 4, '2023-06-01 10:00:00', 'Sophie BRASSE', 5, 1),
(496, 3, 2, '2023-05-30 07:30:00', 'Arthur PLOUF', 8, 1),
(497, 3, 2, '2023-05-30 08:30:00', 'Arthur PLOUF', 8, 1),
(498, 3, 2, '2023-05-30 09:30:00', 'Arthur PLOUF', 8, 1),
(499, 3, 2, '2023-05-30 10:30:00', 'Arthur PLOUF', 8, 1),
(500, 3, 2, '2023-05-31 07:30:00', 'Arthur PLOUF', 8, 1),
(501, 3, 2, '2023-05-31 08:30:00', 'Arthur PLOUF', 8, 1),
(502, 3, 2, '2023-05-31 09:30:00', 'Arthur PLOUF', 8, 1),
(503, 3, 2, '2023-05-31 10:30:00', 'Arthur PLOUF', 8, 1),
(504, 3, 2, '2023-06-01 07:30:00', 'Arthur PLOUF', 8, 1),
(505, 3, 2, '2023-06-01 08:30:00', 'Arthur PLOUF', 8, 1),
(506, 3, 2, '2023-06-01 09:30:00', 'Arthur PLOUF', 8, 1),
(507, 3, 2, '2023-06-01 10:30:00', 'Arthur PLOUF', 8, 1),
(508, 3, 3, '2023-06-02 09:30:00', 'Arthur PLOUF', 8, 1),
(509, 3, 3, '2023-06-02 10:30:00', 'Arthur PLOUF', 8, 1),
(510, 3, 3, '2023-06-03 09:30:00', 'Arthur PLOUF', 8, 1),
(511, 3, 3, '2023-06-03 10:30:00', 'Arthur PLOUF', 8, 1),
(512, 3, 4, '2023-05-29 16:30:00', 'Sophie BRASSE', 10, 1),
(513, 3, 4, '2023-06-02 15:30:00', 'Sophie BRASSE', 10, 1),
(514, 3, 4, '2023-06-02 16:30:00', 'Sophie BRASSE', 10, 1),
(515, 3, 5, '2023-06-02 09:30:00', 'Iris DOE', 4, 1),
(516, 3, 5, '2023-06-03 09:30:00', 'Iris DOE', 4, 1),
(517, 4, 2, '2023-05-30 10:30:00', 'Iris DOE', 10, 1),
(518, 4, 2, '2023-05-30 15:30:00', 'Iris DOE', 10, 1),
(519, 4, 2, '2023-05-31 10:30:00', 'Iris DOE', 10, 1),
(520, 4, 2, '2023-05-31 15:30:00', 'Iris DOE', 10, 1),
(521, 4, 2, '2023-06-01 10:30:00', 'Iris DOE', 10, 1),
(522, 4, 2, '2023-06-01 15:30:00', 'Iris DOE', 10, 1),
(523, 4, 3, '2023-05-29 13:30:00', 'Stacy REINE', 10, 1),
(524, 4, 3, '2023-05-29 17:30:00', 'Stacy REINE', 10, 1),
(525, 4, 3, '2023-05-30 13:30:00', 'Stacy REINE', 10, 1),
(526, 4, 3, '2023-05-30 17:30:00', 'Stacy REINE', 10, 1),
(527, 4, 3, '2023-06-01 13:30:00', 'Stacy REINE', 10, 1),
(528, 4, 3, '2023-06-01 17:30:00', 'Stacy REINE', 10, 1),
(529, 4, 6, '2023-05-29 09:30:00', 'Iris DOE', 1, 1),
(530, 4, 6, '2023-05-29 10:30:00', 'Iris DOE', 1, 1),
(531, 4, 6, '2023-05-29 11:30:00', 'Iris DOE', 1, 1),
(532, 4, 6, '2023-05-30 09:30:00', 'Iris DOE', 1, 1),
(533, 4, 6, '2023-05-30 10:30:00', 'Iris DOE', 1, 1),
(534, 4, 6, '2023-05-30 11:30:00', 'Iris DOE', 1, 1),
(535, 4, 6, '2023-06-01 09:30:00', 'Iris DOE', 1, 1),
(536, 4, 6, '2023-06-01 10:30:00', 'Iris DOE', 1, 1),
(537, 4, 6, '2023-06-01 11:30:00', 'Iris DOE', 1, 1),
(538, 4, 6, '2023-05-31 09:30:00', 'Héléna TASSION', 1, 1),
(539, 4, 6, '2023-05-31 10:30:00', 'Héléna TASSION', 1, 1),
(540, 4, 6, '2023-05-31 11:30:00', 'Héléna TASSION', 1, 1),
(541, 4, 6, '2023-05-31 09:30:00', 'Héléna TASSION', 1, 1),
(542, 4, 6, '2023-06-02 10:30:00', 'Héléna TASSION', 1, 1),
(543, 4, 6, '2023-06-02 11:30:00', 'Héléna TASSION', 1, 1),
(544, 4, 6, '2023-06-02 09:30:00', 'Héléna TASSION', 1, 1),
(545, 4, 6, '2023-06-02 10:30:00', 'Héléna TASSION', 1, 1),
(546, 4, 6, '2023-06-02 11:30:00', 'Héléna TASSION', 1, 1),
(547, 1, 2, '2023-06-05 08:30:00', 'Bernard PAPILLON', 10, 1),
(548, 1, 2, '2023-06-07 16:00:00', 'Bernard PAPILLON', 10, 1),
(549, 1, 2, '2023-06-10 09:30:00', 'Bernard PAPILLON', 10, 1),
(550, 1, 3, '2023-06-06 14:30:00', 'Sophie BRASSE', 10, 1),
(551, 1, 4, '2023-06-07 10:00:00', 'Sophie BRASSE', 15, 1),
(552, 1, 5, '2023-06-10 10:00:00', 'Héléna TASSION', 3, 1),
(553, 1, 6, '2023-06-05 14:00:00', 'Héléna TASSION', 1, 1),
(554, 1, 6, '2023-06-05 15:00:00', 'Héléna TASSION', 1, 1),
(555, 1, 6, '2023-06-05 16:00:00', 'Héléna TASSION', 1, 1),
(556, 1, 6, '2023-06-05 17:00:00', 'Héléna TASSION', 1, 1),
(557, 1, 6, '2023-06-08 08:30:00', 'Héléna TASSION', 1, 1),
(558, 1, 6, '2023-06-08 09:30:00', 'Héléna TASSION', 1, 1),
(559, 1, 6, '2023-06-08 10:30:00', 'Héléna TASSION', 1, 1),
(560, 1, 6, '2023-06-08 11:30:00', 'Héléna TASSION', 1, 1),
(561, 1, 6, '2023-06-07 14:00:00', 'Stacy REINE', 1, 1),
(562, 1, 6, '2023-06-07 15:00:00', 'Stacy REINE', 1, 1),
(563, 1, 6, '2023-06-07 16:00:00', 'Stacy REINE', 1, 1),
(564, 1, 6, '2023-06-07 17:00:00', 'Stacy REINE', 1, 1),
(565, 1, 6, '2023-06-09 09:00:00', 'Stacy REINE', 1, 1),
(566, 1, 6, '2023-06-09 10:00:00', 'Stacy REINE', 1, 1),
(567, 1, 6, '2023-06-09 11:00:00', 'Stacy REINE', 1, 1),
(568, 1, 6, '2023-06-09 13:00:00', 'Stacy REINE', 1, 1),
(569, 1, 6, '2023-06-09 14:00:00', 'Stacy REINE', 1, 1),
(570, 1, 6, '2023-06-09 15:00:00', 'Stacy REINE', 1, 1),
(571, 2, 2, '2023-06-05 09:00:00', 'René NUFFARD', 12, 1),
(572, 2, 2, '2023-06-06 09:00:00', 'René NUFFARD', 12, 1),
(573, 2, 2, '2023-06-07 09:00:00', 'René NUFFARD', 12, 1),
(574, 2, 2, '2023-06-08 09:00:00', 'René NUFFARD', 12, 1),
(575, 2, 2, '2023-06-09 09:00:00', 'René NUFFARD', 12, 1),
(576, 2, 2, '2023-06-10 08:30:00', 'René NUFFARD', 12, 1),
(577, 2, 2, '2023-06-05 15:00:00', 'Armand CHOW', 12, 1),
(578, 2, 2, '2023-06-06 15:00:00', 'Armand CHOW', 12, 1),
(579, 2, 2, '2023-06-07 15:00:00', 'Armand CHOW', 12, 1),
(580, 2, 2, '2023-06-08 15:00:00', 'Armand CHOW', 12, 1),
(581, 2, 2, '2023-06-09 15:00:00', 'Armand CHOW', 12, 1),
(582, 2, 2, '2023-06-10 09:30:00', 'Armand CHOW', 12, 1),
(583, 2, 3, '2023-06-07 09:00:00', 'Armand CHOW', 10, 1),
(584, 2, 3, '2023-06-09 10:30:00', 'Armand CHOW', 10, 1),
(585, 2, 3, '2023-06-10 11:00:00', 'Armand CHOW', 10, 1),
(586, 2, 4, '2023-06-08 10:00:00', 'Sophie BRASSE', 5, 1),
(587, 3, 2, '2023-06-06 07:30:00', 'Arthur PLOUF', 8, 1),
(588, 3, 2, '2023-06-06 08:30:00', 'Arthur PLOUF', 8, 1),
(589, 3, 2, '2023-06-06 09:30:00', 'Arthur PLOUF', 8, 1),
(590, 3, 2, '2023-06-06 10:30:00', 'Arthur PLOUF', 8, 1),
(591, 3, 2, '2023-06-07 07:30:00', 'Arthur PLOUF', 8, 1),
(592, 3, 2, '2023-06-07 08:30:00', 'Arthur PLOUF', 8, 1),
(593, 3, 2, '2023-06-07 09:30:00', 'Arthur PLOUF', 8, 1),
(594, 3, 2, '2023-06-07 10:30:00', 'Arthur PLOUF', 8, 1),
(595, 3, 2, '2023-06-08 07:30:00', 'Arthur PLOUF', 8, 1),
(596, 3, 2, '2023-06-08 08:30:00', 'Arthur PLOUF', 8, 1),
(597, 3, 2, '2023-06-08 09:30:00', 'Arthur PLOUF', 8, 1),
(598, 3, 2, '2023-06-08 10:30:00', 'Arthur PLOUF', 8, 1),
(599, 3, 3, '2023-06-09 09:30:00', 'Arthur PLOUF', 8, 1),
(600, 3, 3, '2023-06-09 10:30:00', 'Arthur PLOUF', 8, 1),
(601, 3, 3, '2023-06-10 09:30:00', 'Arthur PLOUF', 8, 1),
(602, 3, 3, '2023-06-10 10:30:00', 'Arthur PLOUF', 8, 1),
(603, 3, 4, '2023-06-05 16:30:00', 'Sophie BRASSE', 10, 1),
(604, 3, 4, '2023-06-09 15:30:00', 'Sophie BRASSE', 10, 1),
(605, 3, 4, '2023-06-09 16:30:00', 'Sophie BRASSE', 10, 1),
(606, 3, 5, '2023-06-09 09:30:00', 'Iris DOE', 4, 1),
(607, 3, 5, '2023-06-10 09:30:00', 'Iris DOE', 4, 1),
(608, 4, 2, '2023-06-06 10:30:00', 'Iris DOE', 10, 1),
(609, 4, 2, '2023-06-06 15:30:00', 'Iris DOE', 10, 1),
(610, 4, 2, '2023-06-07 10:30:00', 'Iris DOE', 10, 1),
(611, 4, 2, '2023-06-07 15:30:00', 'Iris DOE', 10, 1),
(612, 4, 2, '2023-06-08 10:30:00', 'Iris DOE', 10, 1),
(613, 4, 2, '2023-06-08 15:30:00', 'Iris DOE', 10, 1),
(614, 4, 3, '2023-06-05 13:30:00', 'Stacy REINE', 10, 1),
(615, 4, 3, '2023-06-05 17:30:00', 'Stacy REINE', 10, 1),
(616, 4, 3, '2023-06-06 13:30:00', 'Stacy REINE', 10, 1),
(617, 4, 3, '2023-06-06 17:30:00', 'Stacy REINE', 10, 1),
(618, 4, 3, '2023-06-08 13:30:00', 'Stacy REINE', 10, 1),
(619, 4, 3, '2023-06-08 17:30:00', 'Stacy REINE', 10, 1),
(620, 4, 6, '2023-06-05 09:30:00', 'Iris DOE', 1, 1),
(621, 4, 6, '2023-06-05 10:30:00', 'Iris DOE', 1, 1),
(622, 4, 6, '2023-06-05 11:30:00', 'Iris DOE', 1, 1),
(623, 4, 6, '2023-06-06 09:30:00', 'Iris DOE', 1, 1),
(624, 4, 6, '2023-06-06 10:30:00', 'Iris DOE', 1, 1),
(625, 4, 6, '2023-06-06 11:30:00', 'Iris DOE', 1, 1),
(626, 4, 6, '2023-06-08 09:30:00', 'Iris DOE', 1, 1),
(627, 4, 6, '2023-06-08 10:30:00', 'Iris DOE', 1, 1),
(628, 4, 6, '2023-06-08 11:30:00', 'Iris DOE', 1, 1),
(629, 4, 6, '2023-06-07 09:30:00', 'Héléna TASSION', 1, 1),
(630, 4, 6, '2023-06-07 10:30:00', 'Héléna TASSION', 1, 1),
(631, 4, 6, '2023-06-07 11:30:00', 'Héléna TASSION', 1, 1),
(632, 4, 6, '2023-06-07 09:30:00', 'Héléna TASSION', 1, 1),
(633, 4, 6, '2023-06-09 10:30:00', 'Héléna TASSION', 1, 1),
(634, 4, 6, '2023-06-09 11:30:00', 'Héléna TASSION', 1, 1),
(635, 4, 6, '2023-06-09 09:30:00', 'Héléna TASSION', 1, 1),
(636, 4, 6, '2023-06-09 10:30:00', 'Héléna TASSION', 1, 1),
(637, 4, 6, '2023-06-09 11:30:00', 'Héléna TASSION', 1, 1),
(638, 1, 2, '2023-06-12 08:30:00', 'Bernard PAPILLON', 10, 1),
(639, 1, 2, '2023-06-14 16:00:00', 'Bernard PAPILLON', 10, 1),
(640, 1, 2, '2023-06-17 09:30:00', 'Bernard PAPILLON', 10, 1),
(641, 1, 3, '2023-06-13 14:30:00', 'Sophie BRASSE', 10, 1),
(642, 1, 4, '2023-06-14 10:00:00', 'Sophie BRASSE', 15, 1),
(643, 1, 5, '2023-06-17 10:00:00', 'Héléna TASSION', 3, 1),
(644, 1, 6, '2023-06-12 14:00:00', 'Héléna TASSION', 1, 1),
(645, 1, 6, '2023-06-12 15:00:00', 'Héléna TASSION', 1, 1),
(646, 1, 6, '2023-06-12 16:00:00', 'Héléna TASSION', 1, 1),
(647, 1, 6, '2023-06-12 17:00:00', 'Héléna TASSION', 1, 1),
(648, 1, 6, '2023-06-15 08:30:00', 'Héléna TASSION', 1, 1),
(649, 1, 6, '2023-06-15 09:30:00', 'Héléna TASSION', 1, 1),
(650, 1, 6, '2023-06-15 10:30:00', 'Héléna TASSION', 1, 1),
(651, 1, 6, '2023-06-15 11:30:00', 'Héléna TASSION', 1, 1),
(652, 1, 6, '2023-06-14 14:00:00', 'Stacy REINE', 1, 1),
(653, 1, 6, '2023-06-14 15:00:00', 'Stacy REINE', 1, 1),
(654, 1, 6, '2023-06-14 16:00:00', 'Stacy REINE', 1, 1),
(655, 1, 6, '2023-06-14 17:00:00', 'Stacy REINE', 1, 1),
(656, 1, 6, '2023-06-16 09:00:00', 'Stacy REINE', 1, 1),
(657, 1, 6, '2023-06-16 10:00:00', 'Stacy REINE', 1, 1),
(658, 1, 6, '2023-06-16 11:00:00', 'Stacy REINE', 1, 1),
(659, 1, 6, '2023-06-16 13:00:00', 'Stacy REINE', 1, 1),
(660, 1, 6, '2023-06-16 14:00:00', 'Stacy REINE', 1, 1),
(661, 1, 6, '2023-06-16 15:00:00', 'Stacy REINE', 1, 1),
(662, 2, 2, '2023-06-12 09:00:00', 'René NUFFARD', 12, 1),
(663, 2, 2, '2023-06-13 09:00:00', 'René NUFFARD', 12, 1),
(664, 2, 2, '2023-06-14 09:00:00', 'René NUFFARD', 12, 1),
(665, 2, 2, '2023-06-15 09:00:00', 'René NUFFARD', 12, 1),
(666, 2, 2, '2023-06-16 09:00:00', 'René NUFFARD', 12, 1),
(667, 2, 2, '2023-06-17 08:30:00', 'René NUFFARD', 12, 1),
(668, 2, 2, '2023-06-12 15:00:00', 'Armand CHOW', 12, 1),
(669, 2, 2, '2023-06-13 15:00:00', 'Armand CHOW', 12, 1),
(670, 2, 2, '2023-06-14 15:00:00', 'Armand CHOW', 12, 1),
(671, 2, 2, '2023-06-15 15:00:00', 'Armand CHOW', 12, 1),
(672, 2, 2, '2023-06-16 15:00:00', 'Armand CHOW', 12, 1),
(673, 2, 2, '2023-06-17 09:30:00', 'Armand CHOW', 12, 1),
(674, 2, 3, '2023-06-14 09:00:00', 'Armand CHOW', 10, 1),
(675, 2, 3, '2023-06-16 10:30:00', 'Armand CHOW', 10, 1),
(676, 2, 3, '2023-06-17 11:00:00', 'Armand CHOW', 10, 1),
(677, 2, 4, '2023-06-15 10:00:00', 'Sophie BRASSE', 5, 1),
(678, 3, 2, '2023-06-13 07:30:00', 'Arthur PLOUF', 8, 1),
(679, 3, 2, '2023-06-13 08:30:00', 'Arthur PLOUF', 8, 1),
(680, 3, 2, '2023-06-13 09:30:00', 'Arthur PLOUF', 8, 1),
(681, 3, 2, '2023-06-13 10:30:00', 'Arthur PLOUF', 8, 1),
(682, 3, 2, '2023-06-14 07:30:00', 'Arthur PLOUF', 8, 1),
(683, 3, 2, '2023-06-14 08:30:00', 'Arthur PLOUF', 8, 1),
(684, 3, 2, '2023-06-14 09:30:00', 'Arthur PLOUF', 8, 1),
(685, 3, 2, '2023-06-14 10:30:00', 'Arthur PLOUF', 8, 1),
(686, 3, 2, '2023-06-15 07:30:00', 'Arthur PLOUF', 8, 1),
(687, 3, 2, '2023-06-15 08:30:00', 'Arthur PLOUF', 8, 1),
(688, 3, 2, '2023-06-15 09:30:00', 'Arthur PLOUF', 8, 1),
(689, 3, 2, '2023-06-15 10:30:00', 'Arthur PLOUF', 8, 1),
(690, 3, 3, '2023-06-16 09:30:00', 'Arthur PLOUF', 8, 1),
(691, 3, 3, '2023-06-16 10:30:00', 'Arthur PLOUF', 8, 1),
(692, 3, 3, '2023-06-17 09:30:00', 'Arthur PLOUF', 8, 1),
(693, 3, 3, '2023-06-17 10:30:00', 'Arthur PLOUF', 8, 1),
(694, 3, 4, '2023-06-12 16:30:00', 'Sophie BRASSE', 10, 1),
(695, 3, 4, '2023-06-16 15:30:00', 'Sophie BRASSE', 10, 1),
(696, 3, 4, '2023-06-16 16:30:00', 'Sophie BRASSE', 10, 1),
(697, 3, 5, '2023-06-16 09:30:00', 'Iris DOE', 4, 1),
(698, 3, 5, '2023-06-17 09:30:00', 'Iris DOE', 4, 1),
(699, 4, 2, '2023-06-13 10:30:00', 'Iris DOE', 10, 1),
(700, 4, 2, '2023-06-13 15:30:00', 'Iris DOE', 10, 1),
(701, 4, 2, '2023-06-14 10:30:00', 'Iris DOE', 10, 1),
(702, 4, 2, '2023-06-14 15:30:00', 'Iris DOE', 10, 1),
(703, 4, 2, '2023-06-15 10:30:00', 'Iris DOE', 10, 1),
(704, 4, 2, '2023-06-15 15:30:00', 'Iris DOE', 10, 1),
(705, 4, 3, '2023-06-12 13:30:00', 'Stacy REINE', 10, 1),
(706, 4, 3, '2023-06-12 17:30:00', 'Stacy REINE', 10, 1),
(707, 4, 3, '2023-06-13 13:30:00', 'Stacy REINE', 10, 1),
(708, 4, 3, '2023-06-13 17:30:00', 'Stacy REINE', 10, 1),
(709, 4, 3, '2023-06-15 13:30:00', 'Stacy REINE', 10, 1),
(710, 4, 3, '2023-06-15 17:30:00', 'Stacy REINE', 10, 1),
(711, 4, 6, '2023-06-12 09:30:00', 'Iris DOE', 1, 1),
(712, 4, 6, '2023-06-12 10:30:00', 'Iris DOE', 1, 1),
(713, 4, 6, '2023-06-12 11:30:00', 'Iris DOE', 1, 1),
(714, 4, 6, '2023-06-13 09:30:00', 'Iris DOE', 1, 1),
(715, 4, 6, '2023-06-13 10:30:00', 'Iris DOE', 1, 1),
(716, 4, 6, '2023-06-13 11:30:00', 'Iris DOE', 1, 1),
(717, 4, 6, '2023-06-15 09:30:00', 'Iris DOE', 1, 1),
(718, 4, 6, '2023-06-15 10:30:00', 'Iris DOE', 1, 1),
(719, 4, 6, '2023-06-15 11:30:00', 'Iris DOE', 1, 1),
(720, 4, 6, '2023-06-14 09:30:00', 'Héléna TASSION', 1, 1),
(721, 4, 6, '2023-06-14 10:30:00', 'Héléna TASSION', 1, 1),
(722, 4, 6, '2023-06-14 11:30:00', 'Héléna TASSION', 1, 1),
(723, 4, 6, '2023-06-14 09:30:00', 'Héléna TASSION', 1, 1),
(724, 4, 6, '2023-06-16 10:30:00', 'Héléna TASSION', 1, 1),
(725, 4, 6, '2023-06-16 11:30:00', 'Héléna TASSION', 1, 1),
(726, 4, 6, '2023-06-16 09:30:00', 'Héléna TASSION', 1, 1),
(727, 4, 6, '2023-06-16 10:30:00', 'Héléna TASSION', 1, 1),
(728, 4, 6, '2023-06-16 11:30:00', 'Héléna TASSION', 1, 1),
(729, 1, 2, '2023-06-19 08:30:00', 'Bernard PAPILLON', 10, 1),
(730, 1, 2, '2023-06-21 16:00:00', 'Bernard PAPILLON', 10, 1),
(731, 1, 2, '2023-06-24 09:30:00', 'Bernard PAPILLON', 10, 1),
(732, 1, 3, '2023-06-20 14:30:00', 'Sophie BRASSE', 10, 1),
(733, 1, 4, '2023-06-21 10:00:00', 'Sophie BRASSE', 15, 1),
(734, 1, 5, '2023-06-24 10:00:00', 'Héléna TASSION', 3, 1),
(735, 1, 6, '2023-06-19 14:00:00', 'Héléna TASSION', 1, 1),
(736, 1, 6, '2023-06-19 15:00:00', 'Héléna TASSION', 1, 1),
(737, 1, 6, '2023-06-19 16:00:00', 'Héléna TASSION', 1, 1),
(738, 1, 6, '2023-06-19 17:00:00', 'Héléna TASSION', 1, 1),
(739, 1, 6, '2023-06-22 08:30:00', 'Héléna TASSION', 1, 1),
(740, 1, 6, '2023-06-22 09:30:00', 'Héléna TASSION', 1, 1),
(741, 1, 6, '2023-06-22 10:30:00', 'Héléna TASSION', 1, 1),
(742, 1, 6, '2023-06-22 11:30:00', 'Héléna TASSION', 1, 1),
(743, 1, 6, '2023-06-21 14:00:00', 'Stacy REINE', 1, 1),
(744, 1, 6, '2023-06-21 15:00:00', 'Stacy REINE', 1, 1),
(745, 1, 6, '2023-06-21 16:00:00', 'Stacy REINE', 1, 1),
(746, 1, 6, '2023-06-21 17:00:00', 'Stacy REINE', 1, 1),
(747, 1, 6, '2023-06-23 09:00:00', 'Stacy REINE', 1, 1),
(748, 1, 6, '2023-06-23 10:00:00', 'Stacy REINE', 1, 1),
(749, 1, 6, '2023-06-23 11:00:00', 'Stacy REINE', 1, 1),
(750, 1, 6, '2023-06-23 13:00:00', 'Stacy REINE', 1, 1),
(751, 1, 6, '2023-06-23 14:00:00', 'Stacy REINE', 1, 1),
(752, 1, 6, '2023-06-23 15:00:00', 'Stacy REINE', 1, 1),
(753, 2, 2, '2023-06-19 09:00:00', 'René NUFFARD', 12, 1),
(754, 2, 2, '2023-06-20 09:00:00', 'René NUFFARD', 12, 1),
(755, 2, 2, '2023-06-21 09:00:00', 'René NUFFARD', 12, 1),
(756, 2, 2, '2023-06-22 09:00:00', 'René NUFFARD', 12, 1),
(757, 2, 2, '2023-06-23 09:00:00', 'René NUFFARD', 12, 1),
(758, 2, 2, '2023-06-24 08:30:00', 'René NUFFARD', 12, 1),
(759, 2, 2, '2023-06-19 15:00:00', 'Armand CHOW', 12, 1),
(760, 2, 2, '2023-06-20 15:00:00', 'Armand CHOW', 12, 1),
(761, 2, 2, '2023-06-21 15:00:00', 'Armand CHOW', 12, 1),
(762, 2, 2, '2023-06-22 15:00:00', 'Armand CHOW', 12, 1),
(763, 2, 2, '2023-06-23 15:00:00', 'Armand CHOW', 12, 1),
(764, 2, 2, '2023-06-24 09:30:00', 'Armand CHOW', 12, 1),
(765, 2, 3, '2023-06-21 09:00:00', 'Armand CHOW', 10, 1),
(766, 2, 3, '2023-06-23 10:30:00', 'Armand CHOW', 10, 1),
(767, 2, 3, '2023-06-24 11:00:00', 'Armand CHOW', 10, 1),
(768, 2, 4, '2023-06-22 10:00:00', 'Sophie BRASSE', 5, 1),
(769, 3, 2, '2023-06-20 07:30:00', 'Arthur PLOUF', 8, 1),
(770, 3, 2, '2023-06-20 08:30:00', 'Arthur PLOUF', 8, 1),
(771, 3, 2, '2023-06-20 09:30:00', 'Arthur PLOUF', 8, 1),
(772, 3, 2, '2023-06-20 10:30:00', 'Arthur PLOUF', 8, 1),
(773, 3, 2, '2023-06-21 07:30:00', 'Arthur PLOUF', 8, 1),
(774, 3, 2, '2023-06-21 08:30:00', 'Arthur PLOUF', 8, 1),
(775, 3, 2, '2023-06-21 09:30:00', 'Arthur PLOUF', 8, 1),
(776, 3, 2, '2023-06-21 10:30:00', 'Arthur PLOUF', 8, 1),
(777, 3, 2, '2023-06-22 07:30:00', 'Arthur PLOUF', 8, 1),
(778, 3, 2, '2023-06-22 08:30:00', 'Arthur PLOUF', 8, 1),
(779, 3, 2, '2023-06-22 09:30:00', 'Arthur PLOUF', 8, 1),
(780, 3, 2, '2023-06-22 10:30:00', 'Arthur PLOUF', 8, 1),
(781, 3, 3, '2023-06-23 09:30:00', 'Arthur PLOUF', 8, 1),
(782, 3, 3, '2023-06-23 10:30:00', 'Arthur PLOUF', 8, 1),
(783, 3, 3, '2023-06-24 09:30:00', 'Arthur PLOUF', 8, 1),
(784, 3, 3, '2023-06-24 10:30:00', 'Arthur PLOUF', 8, 1),
(785, 3, 4, '2023-06-19 16:30:00', 'Sophie BRASSE', 10, 1),
(786, 3, 4, '2023-06-23 15:30:00', 'Sophie BRASSE', 10, 1),
(787, 3, 4, '2023-06-23 16:30:00', 'Sophie BRASSE', 10, 1),
(788, 3, 5, '2023-06-23 09:30:00', 'Iris DOE', 4, 1),
(789, 3, 5, '2023-06-24 09:30:00', 'Iris DOE', 4, 1),
(790, 4, 2, '2023-06-20 10:30:00', 'Iris DOE', 10, 1),
(791, 4, 2, '2023-06-20 15:30:00', 'Iris DOE', 10, 1),
(792, 4, 2, '2023-06-21 10:30:00', 'Iris DOE', 10, 1),
(793, 4, 2, '2023-06-21 15:30:00', 'Iris DOE', 10, 1),
(794, 4, 2, '2023-06-22 10:30:00', 'Iris DOE', 10, 1),
(795, 4, 2, '2023-06-22 15:30:00', 'Iris DOE', 10, 1),
(796, 4, 3, '2023-06-19 13:30:00', 'Stacy REINE', 10, 1),
(797, 4, 3, '2023-06-19 17:30:00', 'Stacy REINE', 10, 1),
(798, 4, 3, '2023-06-20 13:30:00', 'Stacy REINE', 10, 1),
(799, 4, 3, '2023-06-20 17:30:00', 'Stacy REINE', 10, 1),
(800, 4, 3, '2023-06-22 13:30:00', 'Stacy REINE', 10, 1),
(801, 4, 3, '2023-06-22 17:30:00', 'Stacy REINE', 10, 1),
(802, 4, 6, '2023-06-19 09:30:00', 'Iris DOE', 1, 1),
(803, 4, 6, '2023-06-19 10:30:00', 'Iris DOE', 1, 1),
(804, 4, 6, '2023-06-19 11:30:00', 'Iris DOE', 1, 1),
(805, 4, 6, '2023-06-20 09:30:00', 'Iris DOE', 1, 1),
(806, 4, 6, '2023-06-20 10:30:00', 'Iris DOE', 1, 1),
(807, 4, 6, '2023-06-20 11:30:00', 'Iris DOE', 1, 1),
(808, 4, 6, '2023-06-22 09:30:00', 'Iris DOE', 1, 1),
(809, 4, 6, '2023-06-22 10:30:00', 'Iris DOE', 1, 1),
(810, 4, 6, '2023-06-22 11:30:00', 'Iris DOE', 1, 1),
(811, 4, 6, '2023-06-21 09:30:00', 'Héléna TASSION', 1, 1),
(812, 4, 6, '2023-06-21 10:30:00', 'Héléna TASSION', 1, 1),
(813, 4, 6, '2023-06-21 11:30:00', 'Héléna TASSION', 1, 1),
(814, 4, 6, '2023-06-21 09:30:00', 'Héléna TASSION', 1, 1),
(815, 4, 6, '2023-06-23 10:30:00', 'Héléna TASSION', 1, 1),
(816, 4, 6, '2023-06-23 11:30:00', 'Héléna TASSION', 1, 1),
(817, 4, 6, '2023-06-23 09:30:00', 'Héléna TASSION', 1, 1),
(818, 4, 6, '2023-06-23 10:30:00', 'Héléna TASSION', 1, 1),
(819, 4, 6, '2023-06-23 11:30:00', 'Héléna TASSION', 1, 1),
(820, 1, 2, '2023-06-26 08:30:00', 'Bernard PAPILLON', 10, 1),
(821, 1, 2, '2023-06-28 16:00:00', 'Bernard PAPILLON', 10, 1),
(822, 1, 2, '2023-07-01 09:30:00', 'Bernard PAPILLON', 10, 1),
(823, 1, 3, '2023-06-27 14:30:00', 'Sophie BRASSE', 10, 1),
(824, 1, 4, '2023-06-28 10:00:00', 'Sophie BRASSE', 15, 1),
(825, 1, 5, '2023-07-01 10:00:00', 'Héléna TASSION', 3, 1),
(826, 1, 6, '2023-06-26 14:00:00', 'Héléna TASSION', 1, 1),
(827, 1, 6, '2023-06-26 15:00:00', 'Héléna TASSION', 1, 1),
(828, 1, 6, '2023-06-26 16:00:00', 'Héléna TASSION', 1, 1),
(829, 1, 6, '2023-06-26 17:00:00', 'Héléna TASSION', 1, 1),
(830, 1, 6, '2023-06-29 08:30:00', 'Héléna TASSION', 1, 1),
(831, 1, 6, '2023-06-29 09:30:00', 'Héléna TASSION', 1, 1),
(832, 1, 6, '2023-06-29 10:30:00', 'Héléna TASSION', 1, 1),
(833, 1, 6, '2023-06-29 11:30:00', 'Héléna TASSION', 1, 1),
(834, 1, 6, '2023-06-28 14:00:00', 'Stacy REINE', 1, 1),
(835, 1, 6, '2023-06-28 15:00:00', 'Stacy REINE', 1, 1),
(836, 1, 6, '2023-06-28 16:00:00', 'Stacy REINE', 1, 1),
(837, 1, 6, '2023-06-28 17:00:00', 'Stacy REINE', 1, 1),
(838, 1, 6, '2023-06-30 09:00:00', 'Stacy REINE', 1, 1),
(839, 1, 6, '2023-06-30 10:00:00', 'Stacy REINE', 1, 1),
(840, 1, 6, '2023-06-30 11:00:00', 'Stacy REINE', 1, 1),
(841, 1, 6, '2023-06-30 13:00:00', 'Stacy REINE', 1, 1),
(842, 1, 6, '2023-06-30 14:00:00', 'Stacy REINE', 1, 1),
(843, 1, 6, '2023-06-30 15:00:00', 'Stacy REINE', 1, 1),
(844, 2, 2, '2023-06-26 09:00:00', 'René NUFFARD', 12, 1),
(845, 2, 2, '2023-06-27 09:00:00', 'René NUFFARD', 12, 1),
(846, 2, 2, '2023-06-28 09:00:00', 'René NUFFARD', 12, 1),
(847, 2, 2, '2023-06-29 09:00:00', 'René NUFFARD', 12, 1),
(848, 2, 2, '2023-06-30 09:00:00', 'René NUFFARD', 12, 1),
(849, 2, 2, '2023-07-01 08:30:00', 'René NUFFARD', 12, 1),
(850, 2, 2, '2023-06-26 15:00:00', 'Armand CHOW', 12, 1),
(851, 2, 2, '2023-06-27 15:00:00', 'Armand CHOW', 12, 1),
(852, 2, 2, '2023-06-28 15:00:00', 'Armand CHOW', 12, 1),
(853, 2, 2, '2023-06-29 15:00:00', 'Armand CHOW', 12, 1),
(854, 2, 2, '2023-06-30 15:00:00', 'Armand CHOW', 12, 1),
(855, 2, 2, '2023-07-01 09:30:00', 'Armand CHOW', 12, 1),
(856, 2, 3, '2023-06-28 09:00:00', 'Armand CHOW', 10, 1),
(857, 2, 3, '2023-06-30 10:30:00', 'Armand CHOW', 10, 1),
(858, 2, 3, '2023-07-01 11:00:00', 'Armand CHOW', 10, 1),
(859, 2, 4, '2023-06-29 10:00:00', 'Sophie BRASSE', 5, 1),
(860, 3, 2, '2023-06-27 07:30:00', 'Arthur PLOUF', 8, 1),
(861, 3, 2, '2023-06-27 08:30:00', 'Arthur PLOUF', 8, 1),
(862, 3, 2, '2023-06-27 09:30:00', 'Arthur PLOUF', 8, 1),
(863, 3, 2, '2023-06-27 10:30:00', 'Arthur PLOUF', 8, 1),
(864, 3, 2, '2023-06-28 07:30:00', 'Arthur PLOUF', 8, 1),
(865, 3, 2, '2023-06-28 08:30:00', 'Arthur PLOUF', 8, 1),
(866, 3, 2, '2023-06-28 09:30:00', 'Arthur PLOUF', 8, 1),
(867, 3, 2, '2023-06-28 10:30:00', 'Arthur PLOUF', 8, 1),
(868, 3, 2, '2023-06-29 07:30:00', 'Arthur PLOUF', 8, 1),
(869, 3, 2, '2023-06-29 08:30:00', 'Arthur PLOUF', 8, 1),
(870, 3, 2, '2023-06-29 09:30:00', 'Arthur PLOUF', 8, 1),
(871, 3, 2, '2023-06-29 10:30:00', 'Arthur PLOUF', 8, 1),
(872, 3, 3, '2023-06-30 09:30:00', 'Arthur PLOUF', 8, 1),
(873, 3, 3, '2023-06-30 10:30:00', 'Arthur PLOUF', 8, 1),
(874, 3, 3, '2023-07-01 09:30:00', 'Arthur PLOUF', 8, 1),
(875, 3, 3, '2023-07-01 10:30:00', 'Arthur PLOUF', 8, 1),
(876, 3, 4, '2023-06-26 16:30:00', 'Sophie BRASSE', 10, 1),
(877, 3, 4, '2023-06-30 15:30:00', 'Sophie BRASSE', 10, 1),
(878, 3, 4, '2023-06-30 16:30:00', 'Sophie BRASSE', 10, 1),
(879, 3, 5, '2023-06-30 09:30:00', 'Iris DOE', 4, 1),
(880, 3, 5, '2023-07-01 09:30:00', 'Iris DOE', 4, 1),
(881, 4, 2, '2023-06-27 10:30:00', 'Iris DOE', 10, 1),
(882, 4, 2, '2023-06-27 15:30:00', 'Iris DOE', 10, 1),
(883, 4, 2, '2023-06-28 10:30:00', 'Iris DOE', 10, 1),
(884, 4, 2, '2023-06-28 15:30:00', 'Iris DOE', 10, 1),
(885, 4, 2, '2023-06-29 10:30:00', 'Iris DOE', 10, 1),
(886, 4, 2, '2023-06-29 15:30:00', 'Iris DOE', 10, 1),
(887, 4, 3, '2023-06-26 13:30:00', 'Stacy REINE', 10, 1),
(888, 4, 3, '2023-06-26 17:30:00', 'Stacy REINE', 10, 1),
(889, 4, 3, '2023-06-27 13:30:00', 'Stacy REINE', 10, 1),
(890, 4, 3, '2023-06-27 17:30:00', 'Stacy REINE', 10, 1),
(891, 4, 3, '2023-06-29 13:30:00', 'Stacy REINE', 10, 1),
(892, 4, 3, '2023-06-29 17:30:00', 'Stacy REINE', 10, 1),
(893, 4, 6, '2023-06-26 09:30:00', 'Iris DOE', 1, 1);
INSERT INTO `lesson` (`id_lesson`, `id_pool`, `id_activity`, `date_time`, `coach`, `capacity`, `active`) VALUES
(894, 4, 6, '2023-06-26 10:30:00', 'Iris DOE', 1, 1),
(895, 4, 6, '2023-06-26 11:30:00', 'Iris DOE', 1, 1),
(896, 4, 6, '2023-06-27 09:30:00', 'Iris DOE', 1, 1),
(897, 4, 6, '2023-06-27 10:30:00', 'Iris DOE', 1, 1),
(898, 4, 6, '2023-06-27 11:30:00', 'Iris DOE', 1, 1),
(899, 4, 6, '2023-06-29 09:30:00', 'Iris DOE', 1, 1),
(900, 4, 6, '2023-06-29 10:30:00', 'Iris DOE', 1, 1),
(901, 4, 6, '2023-06-29 11:30:00', 'Iris DOE', 1, 1),
(902, 4, 6, '2023-06-28 09:30:00', 'Héléna TASSION', 1, 1),
(903, 4, 6, '2023-06-28 10:30:00', 'Héléna TASSION', 1, 1),
(904, 4, 6, '2023-06-28 11:30:00', 'Héléna TASSION', 1, 1),
(905, 4, 6, '2023-06-28 09:30:00', 'Héléna TASSION', 1, 1),
(906, 4, 6, '2023-06-30 10:30:00', 'Héléna TASSION', 1, 1),
(907, 4, 6, '2023-06-30 11:30:00', 'Héléna TASSION', 1, 1),
(908, 4, 6, '2023-06-30 09:30:00', 'Héléna TASSION', 1, 1),
(909, 4, 6, '2023-06-30 10:30:00', 'Héléna TASSION', 1, 1),
(910, 4, 6, '2023-06-30 11:30:00', 'Héléna TASSION', 1, 1);

-- --------------------------------------------------------

--
-- Structure de la table `lesson_code`
--

CREATE TABLE IF NOT EXISTS `lesson_code` (
  `id_lesson` int(11) UNSIGNED NOT NULL,
  `id_code` int(11) UNSIGNED NOT NULL,
  `booking_date` datetime NOT NULL,
  PRIMARY KEY (`id_lesson`,`id_code`),
  UNIQUE KEY `id_lesson` (`id_lesson`),
  KEY `id_code` (`id_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `lesson_code`
--

INSERT INTO `lesson_code` (`id_lesson`, `id_code`, `booking_date`) VALUES
(1, 1, '2022-12-01 08:38:02');

-- --------------------------------------------------------

--
-- Structure de la table `offer`
--

CREATE TABLE IF NOT EXISTS `offer` (
  `id_offer` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `id_activity` int(11) UNSIGNED NOT NULL,
  `id_situation` int(11) UNSIGNED NOT NULL,
  `nb_entries` int(11) NOT NULL,
  `nb_people` int(11) NOT NULL,
  `validity` int(11) NOT NULL,
  `price` float NOT NULL,
  `active` tinyint(1) NOT NULL,
  PRIMARY KEY (`id_offer`),
  KEY `fk_activity_offer` (`id_activity`),
  KEY `fk_activity_situation` (`id_situation`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `offer`
--

INSERT INTO `offer` (`id_offer`, `id_activity`, `id_situation`, `nb_entries`, `nb_people`, `validity`, `price`, `active`) VALUES
(1, 1, 1, 10, 1, 12, 49.95, 1),
(2, 1, 2, 10, 1, 12, 19.95, 1),
(3, 1, 3, 10, 1, 12, 15.95, 1),
(4, 1, 1, 10, 2, 12, 94.35, 1),
(5, 1, 2, 10, 2, 12, 37.55, 1),
(6, 1, 3, 10, 2, 12, 29.95, 1),
(7, 2, 1, 10, 1, 12, 105.45, 1),
(8, 2, 2, 10, 1, 12, 85.15, 1),
(9, 2, 3, 10, 1, 12, 74.25, 1),
(10, 2, 1, 20, 1, 18, 203, 1),
(11, 2, 2, 20, 1, 18, 165, 1),
(12, 2, 3, 20, 1, 18, 143, 1),
(13, 3, 1, 10, 1, 12, 105.45, 1),
(14, 3, 2, 10, 1, 12, 85.15, 1),
(15, 3, 3, 10, 1, 12, 74.25, 1),
(16, 3, 1, 20, 1, 18, 203, 1),
(17, 3, 2, 20, 1, 18, 165, 1),
(18, 3, 3, 20, 1, 18, 143, 1),
(19, 4, 1, 10, 1, 12, 110, 1),
(20, 4, 3, 10, 1, 12, 95, 1),
(21, 5, 1, 1, 1, 6, 15.35, 1),
(22, 5, 3, 1, 1, 6, 9.85, 1),
(23, 5, 1, 5, 1, 12, 76.5, 1),
(24, 5, 3, 5, 1, 12, 49.15, 1),
(25, 6, 1, 5, 1, 12, 212, 1),
(26, 6, 2, 5, 1, 12, 84, 1),
(27, 6, 3, 5, 1, 12, 68, 1),
(30, 4, 2, 10, 1, 12, 98, 1),
(31, 5, 2, 1, 1, 6, 11.5, 1),
(32, 5, 2, 5, 1, 12, 62.2, 1);

-- --------------------------------------------------------

--
-- Structure de la table `pool`
--

CREATE TABLE IF NOT EXISTS `pool` (
  `id_pool` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `picture` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `map` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id_pool`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `pool`
--

INSERT INTO `pool` (`id_pool`, `name`, `address`, `active`, `picture`, `map`, `description`) VALUES
(1, 'Piscine de Bréquigny', '12 Bd Albert 1er\r\n35000 Rennes', 1, 'view/img/Brequigny.webp', 'view/img/MapBrequigny.png', 'Piscine municipale olympique. Dispose de 2 bassins intérieurs et un bassin nordique.'),
(2, 'Piscine des Gayeulles', '16 avenue des Gayeulles - CS 63126 - 35031 Rennes Cedex', 1, 'view/img/Gayeulles.webp', 'view/img/MapGayeulles.png', 'Bassin de natation de 25 mètres, espace ludique : bassin à vagues, lagune pour les tout-petits, bassin de détente et fosse de plongée.'),
(3, 'Piscine Saint-Georges', '4 rue Gambetta - CS 63126 - 35031 Rennes Cedex', 1, 'view/img/SaintGeorge.jpg', 'view/img/MapSaintGeorge.png', 'Bassin (33,33 x 14 m), profondeur du bassin (1,10 à 3 m), bain-douche (accès rue Gambetta). Piscine décorée par le mosaïste Odorico.'),
(4, 'Piscine Villejean', '1 square d\'Alsace - CS 63126 - 35031 Rennes Cedex', 1, 'view/img/VilleJean.webp', 'view/img/MapVilleJean.png', '2 bassins (25x12,50 m et 12,5x10 m).');

-- --------------------------------------------------------

--
-- Structure de la table `pool_user`
--

CREATE TABLE IF NOT EXISTS `pool_user` (
  `id_user` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `login` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `admin` tinyint(1) NOT NULL,
  PRIMARY KEY (`id_user`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `pool_user`
--

INSERT INTO `pool_user` (`id_user`, `login`, `password`, `name`, `admin`) VALUES
(1, 'admin', 'b440d70e9285f2093b45892e8d1334c123b789ad57e09aefbde4fc342f56d5df', 'Admin-piscines', 1);

-- --------------------------------------------------------

--
-- Structure de la table `situation`
--

CREATE TABLE IF NOT EXISTS `situation` (
  `id_situation` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  PRIMARY KEY (`id_situation`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `situation`
--

INSERT INTO `situation` (`id_situation`, `name`, `active`) VALUES
(1, 'Adulte', 1),
(2, 'Moins de 18 ans', 1),
(3, 'Demandeur d\'emploi', 1);

--
-- Contraintes pour les tables déchargées
--

--
-- Contraintes pour la table `code`
--
ALTER TABLE `code`
  ADD CONSTRAINT `code_ibfk_1` FOREIGN KEY (`id_offer`) REFERENCES `offer` (`id_offer`);

--
-- Contraintes pour la table `lesson`
--
ALTER TABLE `lesson`
  ADD CONSTRAINT `lesson_ibfk_1` FOREIGN KEY (`id_pool`) REFERENCES `pool` (`id_pool`),
  ADD CONSTRAINT `lesson_ibfk_2` FOREIGN KEY (`id_activity`) REFERENCES `activity` (`id_activity`);

--
-- Contraintes pour la table `lesson_code`
--
ALTER TABLE `lesson_code`
  ADD CONSTRAINT `lesson_code_ibfk_1` FOREIGN KEY (`id_lesson`) REFERENCES `lesson` (`id_lesson`),
  ADD CONSTRAINT `lesson_code_ibfk_2` FOREIGN KEY (`id_code`) REFERENCES `code` (`id_code`);

--
-- Contraintes pour la table `offer`
--
ALTER TABLE `offer`
  ADD CONSTRAINT `offer_ibfk_1` FOREIGN KEY (`id_activity`) REFERENCES `activity` (`id_activity`),
  ADD CONSTRAINT `offer_ibfk_2` FOREIGN KEY (`id_situation`) REFERENCES `situation` (`id_situation`);
COMMIT;

